A Demonstration of HYRISE - A Main Memory Hybrid Storage Engine

In this demonstration, we show the performance and the salient architectural features of HYRISE, a main memory hybrid database system. The HYRISE engine automatically partitions tables into vertical partitions of varying widths depending on how the columns of the table are accessed. Using a highly accurate model of cache misses, HYRISE is able to predict the performance of different partitionings, and to automatically select the best partitions using an automated database partitioning algorithm. Our demonstration shows the results of the physical partitioning based on different query workloads, lets the database administrator fine-tune or modify the partitioning using a visual tool, and shows how the various physical designs affect the query plans and the performance of the database as a whole. The administrator can thus experiment with various physical models, and can grasp the potential of hybrid partitionings, which achieve a 20% to 400% performance improvement over pure all-column or all-row designs on our realistic hybrid workload derived from customer applications.